import pandas as pd
import folium

# url = 'https://raw.githubusercontent.com/python-visualization/folium/master/examples/data'
# state_geo = f'{url}/us-states.json'
# state_unemployment = f'{url}/US_Unemployment_Oct2012.csv'
# state_data = pd.read_csv(state_unemployment)

state_geo = f'./d3js-geojson-master/d3js-geojson-master/USA.json'
# print(state_geo)
state_unemployment = 'Choroplethmap.xlsx'
state_data = pd.read_excel(state_unemployment, '2016heroin')
print(state_data.head(5))
# state_data = state_data.values
# print(state_data[0:15])

# m = folium.Map(location=[48, -102], zoom_start=3)
#
# folium.Choropleth(
#     geo_data=state_geo,
#     name='Choropleth folium',
#     data=state_data,
#     # columns=['State', 'Unemployment'],
#     key_on='feature.id',
#     fill_color='YlGn',
#     # fill_color='BuPu',
#     fill_opacity=0.7,
#     line_opacity=0.2,
#     # legend_name='Unemployment Rate (%)'
# ).add_to(m)
#
# folium.LayerControl().add_to(m)

# m

# reset=True,
